package com.pls.dao;


import java.sql.SQLException;
import java.util.List;

import com.pls.domain.*;

public interface EmployeeDAO {
	
	// 	search employee information by Employee Name	
	public EmployeeWorkstation getEmployeeDetailsByName(String firstname, String lastname) throws Exception;
	
	// search employee information by EmployeeId	
	public EmployeeWorkstation searchByEmployeeId(String employeeId) throws Exception; 
	
	//	search employee information by Project
	public Employee searchByProject(String Project);

	// 	should allow wildcard search	
	public List<Employee> getAllEmployee(); 

	// 	get all employee details	
    public List<Project> getEmployeeDetails(String employeeId);
    
	
	// 	get all project list of one employee	
    public List<Project> getProjectList(String employeeId);
    
    // Get employee wildcards by name
    public List<Employee> getEmployeeWildCardByName(String employeeName) throws SQLException, ClassNotFoundException, Exception;
	
    // Get employee wildcards by id
    public List<Employee> getEmployeeWildCardById(int employeeId) throws SQLException, ClassNotFoundException, Exception;
    
    //Get workstation map using firstname and lastname
    public List<EmployeeWorkstation> getEmployeeWorkStationMapByFirstNameAndLastName(String firstName, String lastName) throws Exception;
	
}